<?php if (!defined('BASEPATH')) {
	exit('No direct script access allowed');
}

class Active_con_model extends CI_Model {
	public function __construct() {
		parent::__construct();
	}

	public function get_status($stat,$zone){
	 $sql = "SELECT aa.acct_num acct_num,aa.acct_name acct_name,ae.zone_1 zone_1 FROM ar_account aa
					INNER JOIN ar_entity_address ae ON ae.address_id = aa.acct_addr
			WHERE aa.status = '".$stat."' AND  ae.zone_1  =  '".$zone."' ";

	 $query = $this->db->query($sql);
	 return $query->result();

	}

	public function get_zones(){
	 $query = $this->db->get('ar_zone1_values_v');
	 return $query->result();
	}


}